/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sbmart.smartserver.service;

/**
 *
 * @author albert
 *
 */
public class ServerProcedures {

    // Stored Procedure for GET MST Data with no parameter
    public static final String is_mst_sendhistory_exists = "{ ? = call sbmart.dbo._is_mst_sendhistory_exists(?)}";
    public static final String is_trs_sendhistory_exists = "{ ? = call sbmart.dbo._is_trs_sendhistory_exists(?)}";
    public static final String get_mst_branch = "{call sbmart.dbo._get_gerai(?)}";
    //public static final String get_mst_card = "{call get_mst_card()}";
    public static final String get_mst_code = "{call sbmart.dbo._get_mst_code(?)}";
    public static final String get_mst_hadiah = "{call sbmart.dbo._get_mst_hadiah(?)}";
    public static final String get_mst_item_discount = "{call sbmart.dbo._get_mst_item_discount(?)}";
    public static final String get_mst_item_hpp = "{call sbmart.dbo._get_mst_item_hpp(?)}";
    public static final String get_mst_master = "{call sbmart.dbo._get_mst_master(?)}";
    public static final String get_mst_point_mapping = "{call sbmart.dbo._get_mst_point_mapping(?)}";
    public static final String get_mst_rak_sewa = "{call sbmart.dbo._get_mst_rak_sewa(?)}";
    public static final String get_mst_relation = "{call sbmart.dbo._get_mst_relation(?)}";
    public static final String get_mst_tenant = "{call sbmart.dbo._get_mst_tenant(?)}";
    public static final String get_mst_voucher = "{call sbmart.dbo._get_mst_voucher(?)}";
    //
    // Stored Procedure for GET MST Data with parameter
    public static final String get_branch = "{call sbmart.dbo._get_branch(?)}";
    public static final String get_mst_item = "{call sbmart.dbo._get_mst_item(?)}";
    public static final String get_mst_item_list_display = "{call sbmart.dbo._get_mst_item_list_display(?)}";
    public static final String get_mst_item_price = "{call sbmart.dbo._get_mst_item_price(?)}";
    public static final String get_mst_item_price_promo = "{call sbmart.dbo._get_mst_item_price_promo(?)}";
    public static final String get_mst_item_price_promo_active = "{call sbmart.dbo._get_mst_item_price_promo_active(?)}";
    public static final String get_mst_item_vendor = "{call sbmart.dbo._get_mst_item_vendor(?)}";
    public static final String get_mst_modul_produk = "{call sbmart.dbo._get_mst_modul_produk(?)}";
    public static final String get_mst_item_last_cost = "{call sbmart.dbo._get_mst_item_last_cost(?)}";
    public static final String put_mst_item_stok = "{call sbmart.dbo._put_mst_item_stok(?,?,?,?,?,?)}";
    //
    // Stored Procedure for PUT TRX Data   
    public static final String put_trs_bkl_mst = "{ ? = call sbmart.dbo._put_trs_bkl_mst(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_bkl_detail = "{call sbmart.dbo._put_trs_bkl_detail(?,?,?,"
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_order_intern_mst = "{ ? = call sbmart.dbo._put_trs_order_intern_mst(?,?,?,"
            + "?,?,?,?,?,?,?,?)}";
    public static final String put_trs_order_intern_detail = "{ call sbmart.dbo._put_trs_order_intern_detail(?,?,?,?,?,?,?)}";
    public static final String put_trs_retur_bkl_mst = "{ ? = call sbmart.dbo._put_trs_retur_bkl_mst(?,?,"
            + "?,?,?,?,?,?,?,?)}";
    public static final String put_trs_retur_bkl_detail = "{call sbmart.dbo._put_trs_retur_bkl_detail(?,?,"
            + "?,?,?,?,?,?)}";
    public static final String put_trs_retur_gerai_mst = "{ ? = call sbmart.dbo._put_trs_retur_gerai_mst(?,?,?,"
            + "?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_retur_gerai_detail = "{call sbmart.dbo._put_trs_retur_gerai_detail(?,?, "
            + "?,?,?,?,?)}";
    public static final String put_trs_retur_other_mst = "{ ? = call sbmart.dbo._put_trs_retur_other_mst(?,?,?, "
            + "?,?,?,?,?)}";
    public static final String put_trs_retur_other_detail = "{call sbmart.dbo._put_trs_retur_other_detail(?,?,"
            + "?,?,?)}";
    // Stored Procedure for PUT TRX Sales
    public static final String put_trs_sales_mst = "{ ? = call sbmart.dbo._put_trs_sales_mst(?,?,?,?,"
            + "?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_sales_detail = "{call sbmart.dbo._put_trs_sales_detail(?,?, "
            + "?,?,?,?,?,?,?,?)}";
    public static final String put_trs_sales_item = "{ ? = call sbmart.dbo._put_trs_sales_item(?,?,?, "
            + "?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_sales_voucher = "{ call sbmart.dbo._put_trs_sales_voucher(?,?,?,?,"
            + "?,?,?,?,?)}";
    public static final String put_trs_sales_online = "{ call sbmart.dbo._put_trs_sales_online(?,?, "
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_sales_remittance = "{ call sbmart.dbo._put_trs_sales_remittance(?,?, "
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
    
    public static final String put_trs_sales_rekap = "{ ? = call sbmart.dbo._put_trs_sales_rekap(?,"
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_rent_payment = "{call sbmart.dbo._put_trs_rent_payment(?,?,?,"
            + "?,?,?,?,?,?,?,?)}";
    public static final String put_trs_adjust_gerai_mst = "{? = call sbmart.dbo._put_trs_adjust_gerai_mst(?,?,?,"
            + "?,?,?,?,?,?,?,?)}";
    public static final String put_trs_adjust_gerai_detail = "{call sbmart.dbo._put_trs_adjust_gerai_detail(?, "
            + "?,?,?,?,?,?,?,?,?)}";
    public static final String put_inv_item_balance = "{call sbmart.dbo._put_inv_item_balance(?,?,?,?,?)}";
    public static final String put_used_voucher_list = "{call sbmart.dbo._put_used_voucher_list(?,?,?)}";
    //
    // Stored Procedure for GET TRX Data
    public static final String put_trs_sendhistory = "{call sbmart.dbo._put_trs_sendhistory(?)}";
    public static final String get_trs_kirim_mst = "{call sbmart.dbo._get_trs_kirim_mst(?)}";
    public static final String get_trs_kirim_detail = "{call sbmart.dbo._get_trs_kirim_detail(?)}";
    public static final String get_trs_kirimp_mst = "{call sbmart.dbo._get_trs_kirimp_mst(?)}";
    public static final String get_trs_kirimp_detail = "{call sbmart.dbo._get_trs_kirimp_detail(?)}";
    public static final String get_trs_rent_terrace = "{call sbmart.dbo._get_trs_rent_terrace(?)}";
    public static final String get_mst_set_finsert = "{call sbmart.dbo._get_mst_set_finsert(?)}";
    public static final String set_mst_sendtables = "{call sbmart.dbo._set_mst_sendtables(?)}";
    public static final String put_mst_sendhistory = "{call sbmart.dbo._put_mst_sendhistory(?)}";
    public static final String put_trs_sendhistory_gerai = "{call sbmart.dbo._put_trs_sendhistory_gerai(?,?,?,?,?)}";
    public static final String get_mst_connection = "{call sbmart.dbo._get_mst_connection()}";
    //
    // Human Resource
    public static final String put_tr_absensi = "{call sbmart.dbo._put_tr_absensi(?,?,?,?,?,?)}";
    public static final String get_tr_mutasi_dest = "{call sbmart.dbo._get_tr_mutasi_dest(?)}";
    public static final String get_tr_mutasi_src = "{call sbmart.dbo._get_tr_mutasi_src(?)}";
    public static final String put_tr_request = "{call sbmart.dbo._put_tr_request(?,?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String get_mst_pkm_gerai = "{call sbmart.dbo._get_mst_pkm_gerai(?)}";
    public static final String put_trs_mitra_payment_mst = "{call sbmart.dbo._put_trs_mitra_payment_mst(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_trs_mitra_payment_detail = "{call sbmart.dbo._put_trs_mitra_payment_detail(?,?,?,?,?,?,?,?,?,?)}";
    public static final String put_mst_item_request = "{call sbmart.dbo._put_mst_item_request(?,?,?,?,?,?,?,?,?,?)}";
}
